Generic JDBC Data Source

Please enter the following parameters to connect to a JDBC data source:

• Alias: name of the data source to be used in CData Virtuality Server
• Connection URL: URL to connect to the data source
• Driver: JDBC driver name
• Driver class: JDBC driver class
• User name / password: credentials to connect to the data source
• Translator name: name of the translator that will be used to connect to the data source. If left empty, jdbc-ansi will be taken as the translator name.
• Data source parameters: additional connection parameters
• Translator parameters: additional translator parameters

Below are some examples of the most common data source parameters, see the reference manual for the full list:

• importer.useFullSchemaName=TRUE - schema names will be prefixed to table names to avoid duplicates
• importer.importProcedures=TRUE - stored procedures will be imported
• importer.useProcedureSpecificName=TRUE - when two stored procedures being imported have identical names, an index will be appended to their names in order to avoid conflicts

To test the connection parameters press the Test connection button.

RDBMS Table Types

This section shows all the possible table types that can be retrieved for a particular RDBMS server with the importer.tableTypes property.

• ALIAS
• HIERARCHY TABLE
• INOPERATIVE VIEW
• MATERIALIZED QUERY TABLE
• NICKNAME
• SYSTEM TABLE
• TABLE
• TYPED TABLE
• TYPED VIEW
• VIEW

• SYSTEM TABLE
• TABLE
• TABLE LINK
• VIEW

• SYSTEM TABLE
• TABLE
• VIEW
• MS SQL jTDS
• SYSTEM TABLE
• TABLE
• VIEW

• LOCAL TEMPORARY
• TABLE
• VIEW
• Oracle
• SYNONYM
• TABLE
• VIEW

• FOREIGN TABLE
• SYSTEM TABLE
• SYSTEM TOAST INDEX
• SYSTEM TOAST TABLE
• SYSTEM VIEW
• TABLE
• TEMPORARY INDEX
• TEMPORARY SEQUENCE
• TEMPORARY TABLE
• TEMPORARY VIEW
• TYPE
• VIEW